﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_InsertPersonLocation')
	BEGIN
		DROP  Procedure  esf_sso.P_InsertPersonLocation
	END

GO

CREATE Procedure esf_sso.P_InsertPersonLocation
	@pLocationID			INT
	,@pPersonID				INT
AS

	INSERT INTO [esf_sso].[Person_Location]
		([PersonID], LocationID)
     VALUES
		(@pPersonID, @pLocationID)
           
GO